package cn.com.cabinet.dao;

import java.util.List;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;

import com.cabinet.web.entity.Order;

public interface OrderDao extends JpaRepository<Order, Long>,JpaSpecificationExecutor<Order>{
	
	@Query(nativeQuery=true,value="select * from ict_order limit ?1,?2")
	public List<Order> getOrderListLimit(Integer page,Integer limit);
	
	@Query("select o from Order o")
	public List<Order> getOrderList();

}
